Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 SESSION_START();
7 ?>
8 <?php
9
10 if (isset($_POST['delete'])){
11 $id=$GET['id'];
12 $sql="DELETE FROM intake WHERE intake_id=$id";
13 mysqli_query($conn,$db,$sql);
14
15 echo "Deleted Succsessfully";
16 }
17 ?>
18
19 <!DOCTYPE html>
20 <html>
21
22 <head>
23 <meta charset="utf-8">
24 <meta name="viewport" content="width=device-width, initial-scale=1.0">
25 <title>school management system</title>
26 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
27 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
28 <link href="assets/css/loader.css" rel="stylesheet" />
29 <script src="assets/js/canvasjs.min.js"></script>
30 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
31 <script src="assets/js/jquery-3.2.1.js"></script>
32 </head>
33
34 <body >
35 <!--end of heading section-->
36 <ul class="nav navbar-right top-nav">
37 <div class="dropdown">
38 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
39 <?php
40 //Check to see if the user is logged in.if not redirect user to the loging page.
41
42 if(isset($_SESSION['fname']))
43 {
44 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
45 $currentuser=$_SESSION['fname']. " ".$_SESSION['lname'];
46 }else{
47 echo "<script type='text/javascript'>
48 alert( 'You must Log in to use the system');
49 </script>";
50 echo "<script>
51 window.location = 'index.php'
52 </script>";
53 }
54 ?>
55 <span class="caret"></span></button>
56 <ul class="dropdown-menu">
57 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
58 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
59 <li class="divider"></li>
60 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
61 </ul>
62 </div>
63 </ul>
64 <!--************************************************-->
65 <div style="
66 font-family:Nyala, Arial;
67 text-align: left;
68 background-color: #526F35;
69 padding: 20px;
70 color:white;
71 width: 100%;
72 height: 150px;">
73 <!--This codes to load the image loader-->
74 <div id="loading">
75 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
76 </div>
77 <!--this is the heading section-->
78 <h2>
79 <?php
80 $sql="SELECT * FROM companyinfo";
81 $result=mysqli_query($db,$sql) or die("error getting data");
82 $num_rows=mysqli_num_rows($result);
83 while($row=mysqli_fetch_array($result))
84 {
85 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
86 $cname = $row['cname'];
87 $cemail = $row['cemail'];
88 $ccontact = $row['ccontact'];
89 $clocation = $row['clocation'];
90 }?>
91 <?php
92 echo $cname;
93 ?>
94
95 <div style="float:right; font-size:20px;text-align:right;">
96
97 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
98 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
99 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
100
101 </div>
102 </h2>
103 </div>
104 <!--end of heading section-->
105
106 <div>
107 <ul class="nav nav-tabs">
108 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
109 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
110 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
111 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
112 <li ><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
113 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
114 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
115 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
116 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
117 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
118
119 </ul>
120 <div class="tab-content">
121 <div class="tab-pane active" role="tabpanel" id="tab-1">
122
123 <p>
124 <div class="table-responsive" >
125 <!--****************************************************************************-->
126 <div class="container" style="width:100%">
127
128 <ul class="nav nav-tabs">
129 <li class="active"><a href="#">New Asset<img src="assets/img/new.png"> </a></li>
130 <li ><a href="view_inventory.php">View List<img src="assets/img/view2.png"> </a></li>
131 <li ><a href="edit_inventory.php">Edit<img src="assets/img/edit2.png"> </a></li>
132 <li ><a href="dispose_inventory.php">Dispose/ Write off<img src="assets/img/dispose.png"> </a></li>
133 <li ><a href="reports_inventory.php">Reports<img src="assets/img/report2.png"> </a></li>
134 </ul>
135 <br>
136
137 </div>
138
139 <!--*************************************************************************************************************************-->
140 <div class="container-fluid">
141 <div class="row">
142 <div class="col-lg-6 col-lg-offset-3">
143 <div class="panel panel-primary">
144 <div class="panel-heading">Add new Asset</div>
145
146 <!-- /.panel-heading -->
147 <div class="panel-body">
148 <div class="table">
149 <form action="inventory.php" method="POST" enctype="multipart/form-data">
150
151 <label>Asset code/Name [<font color="red">*</font>]</label>
152 <input type="text" name="asset_code" class="form-control">
153 <label>Date Purchased [<font color="red">*</font>]</label>
154 <input type="DATE" name="date_purchased" class="form-control" value="<?php echo date('Y-m-d'); ?>">
155 <label>Estimated_value</label>
156 <input type="number" name="estimated_value" class="form-control">
157 <label>location</label>
158 <input type="text" name="location" class="form-control">
159 <label>model_make</label>
160 <input type="text" name="mode_make" class="form-control">
161 <label>purchase_price</label>
162 <input type="number" name="purchase_price" class="form-control">
163
164 <label>serial_number</label>
165 <input type="text" name="serial_number" class="form-control">
166 <label>condition</label>
167 <input type="text" name="asset_condition" class="form-control">
168 <label>quantity</label>
169 <input type="number" name="quantity" class="form-control">
170 <label>order_number</label>
171 <input type="number" name="order_number" class="form-control">
172 <label>updated_by</label>
173 <input type="text" name="updated_by" readonly class="form-control" value=<?php echo $currentuser; ?>>
174
175 <input type="submit" name="register" value="Add Asset" class="btn btn-success" ><br><br>
176
177 </form>
178 <!--****************************************************************************-->
179 <?php
180 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
181 if (isset($_POST['register'])){
182
183 $asset_code=$_POST['asset_code'];
184 $date_purchased=$_POST['date_purchased'];
185 $estimated_value=$_POST['estimated_value'];
186 $location=$_POST['location'];
187 $mode_make=$_POST['mode_make'];
188 $purchase_price=$_POST['purchase_price'];
189 $serial_number=$_POST['serial_number'];
190 $asset_condition=$_POST['asset_condition'];
191 $quantity=$_POST['quantity'];
192 $order_number=$_POST['order_number'];
193 $active="yes";
194 $reason_for_disposing="";
195 $updated_by=$_POST['updated_by'];
196
197 mysqli_query($conn,"INSERT INTO `inventory`(`asset_code`, `date_purchased`, `estimated_value`, `location`, `mode_make`, `purchase_price`, `serial_number`, `asset_condition`, `quantity`, `order_number`, `active`,`reason_for_disposing`, `updated_by`) VALUES ('$asset_code','$date_purchased','$estimated_value','$location','$mode_make','$purchase_price','$serial_number','$asset_condition','$quantity','$order_number','$active','$reason_for_disposing','$updated_by')") or die(mysqli_error());
198
199
200 ?>
201 <?php
202 $query="SELECT * FROM inventory";
203 $records2=mysqli_query($db,$query);
204 while($rec=mysqli_fetch_array($records2))
205 {
206 $id = $rec['asset_id'];
207 }?>
208
209 <script>
210
211 alert('Succsessfully Save.');
212 window.location = "inventory.php?id=<?php echo $id;?>";
213 </script>
214 <?php
215 //<!--*******************************try add parent's details******************************************************-->
216
217 }?>
218
219 </div>
220 </div>
221 </div>
222 <!-- /.container-fluid -->
223 </div>
224 <!-- /#page-wrapper -->
225 </div>
226 </div>
227
228
229
230
231 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
232 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
233 </div>
234 <script src="assets/js/jquery.min.js"></script>
235 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
236 <script src="assets/js/affix.js"></script>
237 <script src="assets/js/alert.js"></script>
238 <script src="assets/js/alert1.js"></script>
239 <script src="assets/js/bootstrap.js"></script>
240 <script src="assets/js/bootstrap.min.js"></script>
241 <script src="assets/js/bootstrap-datepicker.js"></script>
242 <script src="assets/js/bootstrap-wysihtml5.js"></script>
243 <script src="assets/js/button.js"></script>
244 <script src="assets/js/carousel.js"></script>
245 <script src="assets/js/chosen.jquery.min.js"></script>
246 <script src="assets/js/ckeditor.js"></script>
247 <script src="assets/js/collapse.js"></script>
248 <script src="assets/js/color.js"></script>
249 <script src="assets/js/dropdown.js"></script>
250 <script src="assets/js/DT_bootstrap.js"></script>
251 <script src="assets/js/dynamic.js"></script>
252 <script src="assets/js/ie-emulation-modes-warning.js"></script>
253 <script src="assets/js/jquery.dataTables.js"></script>
254 <script src="assets/js/jquery.dataTables.min.js"></script>
255 <script src="assets/js/jquery.dialog.js"></script>
256 <script src="assets/js/jquery.hoverdir.js"></script>
257 <script src="assets/js/jquery.jgrowl.js"></script>
258 <script src="assets/js/jquery.knob.js"></script>
259 <script src="assets/js/jquery.uniform.min.js"></script>
260 <script src="assets/js/jquery-1.8.3.min.js"></script>
261 <script src="assets/js/jquery-1.9.1.js"></script>
262 <script src="assets/js/jquery-1.9.1.min.js"></script>
263 <script src="assets/js/jquery-1.10.2.js"></script>
264 <script src="assets/js/jquery-1.11.0.js"></script>
265 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
266 <script src="assets/js/jquery-ui-1.10.3.js"></script>
267 <script src="assets/js/modal.js"></script>
268 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
269 <script src="assets/js/myjquery.js"></script>
270 <script src="assets/js/myjquery1.js"></script>
271 <script src="assets/js/npm.js"></script>
272 <script src="assets/js/popover.js"></script>
273 <script src="assets/js/profile.js"></script>
274 <script src="assets/js/raphael-min.js"></script>
275 <script src="assets/js/sb-admin-2.js"></script>
276 <script src="assets/js/scripts.js"></script>
277 <script src="assets/js/scrollspy.js"></script>
278 <script src="assets/js/tab.js"></script>
279 <script src="assets/js/tooltip.js"></script>
280 <script src="assets/js/transition.js"></script>
281 <script src="assets/js/wysihtml5-0.3.0.js"></script>
282 <script language="javascript" type="text/javascript">
283 $(window).load(function()
284 {
285 $('#loading').hide();
286 });
287 </script>
288 </body>
289
290 </html>